package com.freud.logic.business.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.freud.logic.business.bean.District;

/**
 * 
 * @author Freud
 */
public interface DistrictMapper {

	@Select("SELECT ID as id, name as name, city_id as cityId FROM DISTRICT")
	public List<District> getAll();

	@Select("SELECT ID as id, name as name, city_id as cityId FROM DISTRICT WHERE ID = #{id}")
	public District getById(@Param("id") int id);

}
